How to: Open a form to a new record.
Solution:
In the Forms Design view, use the 'On Open' property box in the property sheet to open to a new record.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click the 'Event' tab.
7) Click on the 'On Open' box. (A build button appears.)
8) Click 'Build'. (The 'Choose Builder' dialog box appears.)
9) Select 'Macro Builder' from the 'Choose Builder' list.
10) Click 'OK'. (The Save As dialog box appears.)
11) Type the desired name for the macro in the 'Save As' box.
12) Click 'OK'. (The Macro grid appears.)
13) Click on the down arrow of the 'Action' list.
14) Select 'GoToRecord' from the 'Action' drop-down list. (The Action Arguments appears in the lower section of the grid.)
15) Click on the 'Object Type' box. (A down arrow appears.)
16) Click down arrow. (A drop-down list appears.)
17) Select 'Form' from the 'Object Type' drop-down list.
18) Click on the 'Object Name' box. (A down arrow appears.)
19) Click down arrow. (A drop-down list appears.)
20) Select the name of the current form in the 'Object Name' drop-down list.
21) Click on the 'Record' box. (A down arrow appears.)
22) Click down arrow. (A drop-down arrow appears.)
23) Select 'New' from the 'Record' drop-down list.
24) Select the 'File' menu and select 'Save' to save changes to the macro.
25) Click on the 'X' in the upper right corner of the 'Macro' window to close the macro. (The macro name appears in the On Open box of the property sheet.)
26) Select the 'File' menu and select 'Save' to save changes to the form.
